Welcome to the first coding video on financial portfolios.
And before we can create analyze and optimize portfolios we need to import the data and for comparison
and simplicity reasons.
We again use the six stocks Amazon Boeing Disney IBM Coca-Cola and Microsoft.
And we can either download them directly from Yahoo Finance with the White finance library or we can
simply import our index stocks we file and in this case we decide to go for the second alternative.
So first of all we import pandas and then we import our stock data from our CSP file and we create a
daytime index and we save the data and the variable stocks.
So let's have a look here.
And we can see that we have the adjusted close at the close open low and volume for the stocks and us
working with and analyzing portfolios is all about performance and the total return so far this section
here we choose the adjusted close prices so the adjusted close prices reflect Actually the total return
and include also dividend payments.
And let us therefore look at the last five rows.
So we are here we have data from 2000 and thirteen.
The very end of 2013 until the end of 2000 and 18.
And as I said we only selected the adjusted close column and actually we override our stocks data frame.
So this is here the adjusted close for our six stocks.
So that's the data that we are working with and the next videos.
And actually we export here our new data frame and save the data in the new CSP file portfolio of stocks.
So let's do this so now in our file we created the CSP file portfolio stocks and with this we are finished
with this video and I hope to see you also in the next one SPI.